MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Inventory System / Product Sales (.txt) < prev

Wrap

FileMaker Pro Database | 1996-01-25 | 138KB | 949 lines

HBAM2016AUG95 Pro 3.0 es.eunet.pdsoft! s133 1 es.eunet.spanish-tex! s191 1 es.eunet.taylor-uucp! s5 1 es.faecad! s4 1 es.faenet! s3 1 es.foro.c! s17 1 es.foro.comms! s18 1 es.foro.lenguajes! s62 1 es.foro.unix! s82 1 es.mania.info! s12 1 es.mania.ip! s6 1 es.mania.iris! s3 1 es.mania.mail! s39 0 es.misc! s481 1 es.neuras! s795 0 es.news! s18 1 es.news.admin! s284 1 es.news.groups! s66 1 es.rec.deportes! s1324 0 es.rediris! s11 1 es.rediris.fallored! s41 0 es.sistemas.informacion! s72 1 es.super! s4 1 HBAM3016AUG95@ HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 o 3.0 AMOUNT DUE AMOUNT PAID CREATED BY CUSTOMER ADDRESS CUSTOMER CITY CUSTOMER COMPANY CUSTOMER COUNTRY CUSTOMER FAX CUSTOMER ID CUSTOMER NAME CUSTOMER PHONE CUSTOMER STATE CUSTOMER ZIP CODE DATE CREATED DATE MODIFIED DISCOUNT DISCOUNT RATE F.O.B. INVOICE DATE INVOICE ID INVOICE TOTAL LAST LAYOUT L SALES TAX SALES TAX RATE - SHIP DATE SHIP VIA SHIPPING SHIPPING RATE SUBTOTAL TERMS WEIGHT Invoice IDB Customer NameB Invoice DateB Customer AddressB Customer State FileMaker Pro 3.0 Folder Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/27/95 Description Use this database file to track purchase orders. FileMaker Pro automatically calculates sales tax and product discounts. How to use this solution You can update the sales tax and discount rate by updating the values in those fields How to customize this solution You can look up the customer information from your own Customers file based on the Customer ID field. You can create a new file with your shippers rates by ZIP Code, and then redefine the Shipping Rate field to autoB:matically look up the rate based on the Customer ZIP Code. Form View - Sale A List View Invoice Report Information Report Menu @>A!Form View - Customer and Shipping Form View - SaleB Customer ZIP CodeB Date CreatedB Date ModifiedB Customer CityB Customer CompanyB SubtotalB Sales Tax RateB .A Sales TaxB 4) * ShippingB Invoice TotalB Discount RateB DiscountB 7A Ship DateB TermsB Net 30 F.O.B.B Ship ViaB Ground WeightB Created ByB InfoB Customer IDB Amount PaidB Amount DueB Customer CountryB Shipping RateB Customer PhoneB Customer FaxB Last LayoutB A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Enter data for Product Sales Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Customer & Shipping Product Sales Line Items File... Inventory File... Invoice ID Invoice Date Subtotal Discount Shipping Total Prod. ID Description Price Extended Amount Subtotal Discount Shipping Total Prod. ID Description Price Extended Amount Cust. ID Company Amount Paid Amount Due Discount Rate Tax Rate Ship Date Terms Invoice ReportB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Totalb Customer Namec Dated Invoice IDe&Click to see more information for Salef Infog Closeh View As Formi View As Listj Reportsk Recordl Delete Recordm Recordn Your Own Buttono Your Own Button Customer Company u Ship Date InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Extended Amount Price Quantity Description Weight Invoice Total Shipping Discount Subtotal Ship Via n Ship Date F.O.B. Terms Extended Amount Price Quantity Description Weight Invoice Total Shipping Discount Subtotal Ship Via n Ship Date F.O.B. Terms Customer Invoice Date Invoice Company Name and Logo Close View As View As Reports Your Own Button ABCA>>, << ABAI>> << ABAK>> ABEG>> Invoice ID Product ID Report MenuB P-Information about the Purchase Sales solutionQ Info for this SolutionS InfoT CloseU View As FormV View As ListW ReportsX Your Own Button View As FormV View As ListW ReportsX Your Own Button Your Own ReportI Your Own ReportJ InvoiceK Your Own ReportL>Click on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button A!Form View - Customer and ShippingB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Invoice Date Invoice ID Enter data for Product Sales Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Sales Inventory File... Line Items File... Company Address City / State / ZIP Code Country Customer & Shipping Shipping: View As Reports Record Delete Record Record Your Own Button Your Own Button Product Sales Inventory File... Line Items File... Company Address City / State / ZIP Code Country Customer & Shipping Shipping: Rate ($/lb) Weight (lbs) Ship Date Ship Via F.O.B. Customer Shipping Phone Joel DavisE 5/5/95G 2301 Pennings CircleH 87154Y 10/5/95` Santa Fea Acme Industriesm 5/25/95x Net 30y New Yorkz Ground 216.68 505-555-6472 505-555-6438 George RahallE 10/5/95G 1782 W. 18th St.H 98668X 10/5/95Y 10/7/95` Vancouvera The Art Gallerym 10/5/95x Net 30z Ground| Paul Farrah 206-555-1219 InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Information List View Report Menu Open Inventory File Sort by Date Sort by Sold To Company Sort by Sold To Name Invoice Report Open Script Dial Phone Sort by Date Invoice Report Sort by Sold To Company Open Script ria; all records will be displayed. Sort by Sold To Name Open Inventory File Dial Phone Information A List View Report Menu Cancel No records match this request.C+ ) = 1 Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif wwwwww ffffff UUUUUU DDDDDD 3333DD wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw >RPTH FPTHA>HARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Productl.fp3 NAMEA Productl.fp3 RPTHA Productl.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ HRPTH FPTHAHHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Line Items.fp3 NAMEA Product Line Items.fp3 RPTHA Product Line Items.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ GRPTH FPTHAGHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Inventory.fp3 NAMEA Product Inventory.fp3 RPTHA Product Inventory.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ (LIST LISTA Ground VDEFA( ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364, M4%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD 333333 #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 DDDD@ """"$ DD1AAA4D@ #DDDDC "System (LIST LISTA Net 7 Net 14 Net 30 VDEFA( (LIST VDEFA( Ship Via ListB Terms ListC Product List FMRLA Product Line Items )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E+ ) = 1